package com.yl.auth.mapper;

import com.yl.auth.model.entity.JiaShu;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * <p>
 * Mapper 接口
 * </p>
 *
 * @author L
 * @since 2023-06-16
 */
@Mapper
public interface JiaShuMapper extends BaseMapper<JiaShu> {
//    @Select("select l.avatar lavatar,l.id,l.`name` lname,l.gender lgender,l.nationality,l.origin,l.birth_date,l.address laddress,l.social_security_number,hl.dengji,l.admission_date,ch.bed_no,f.room_no,b.newbingshi,b.oldbingshi,b.descbingshi from laoren l\n" +
//            "            LEFT JOIN chuangwei ch on l.bed_id=ch.id\n" +
//            "            LEFT JOIN hulidengji hl on l.care_level_id=hl.id\n" +
//            "            LEFT JOIN jiashu jia on jia.laoren_id=l.id\n" +
//            "            LEFT JOIN fangjian f on ch.room_id=f.id\n" +
//            "\t\t\t\t\t\tLEFT JOIN bingshi b on b.laoren_id=l.id\n" +
//            "            WHERE jia.id=#{id}")
    JiaShu getLR(Integer id);
}
